Hi, there is a bug with and postgres 7.2.4 :
in the postgresVFS when I have the list of the
databases, if I double click on one of them the plugin
will try to get the schemaname, but it doesn't exists
in postgres 7.2.4
This query fails :
SELECT DISTINCT schemaname
FROM pg_tables
After a check the fields of the view pg_tables, the
field schemaname doesn't exists with this version of
postgres.
the existing fields are
tablename
tableowner
hasindexes
hasrules
hastriggers
| Submitted | kpouer - 2005-08-30 - 09:31:53z | Assigned | nobody |
|---|---|---|---|
| Priority | 5 | Category | None |
| Status | Open | Group | None |
| Resolution | None | Visibility | No |
| 2007-03-16 - 17:36:02z svu |
Logged In: YES user_id=681 Originator: NO How does Postgres 7.2.4 distinguishes different schemas/databases/...? |
|---|